Data Storage

All dates and times in the database will be stored in UTC format and will be displayed to the user according to the regional date/time settings.

Data Tables

All information will be stored in database tables.

Audit Trail

Changes to any information stored in the database are logged in audit trail tables.

User Audit Log Service

When installed and configured for a database the User Audit Log Service monitors specified database log tables for changes and records the following whenever a change is logged to the log table:

• Parent item to which the change was associated

• Primary key values (any other identifying values for the table entry)

• Message for the user describing type of change made

• Date/time the change was made

• Username of the user who made the change

• Terminal from which the change was made

Flexible Audit Trail

Two audit trails are included in the system:

1. Table level audit trail maintained by database triggers that will log any data changes automatically – currently implemented in baseline AccuSOLO.

2. A flexible audit trail that provides summary information about updates that took place recording what was performed, from which terminal, who did it, and (date/time) when it was done. This audit trail also allows the user entered comments. The flexible audit trail is available for the following:

Loads

1. In the Loads Management module, edit a load.

2. On the Edit Loads form, click View History.

   

User Management

1. In the User Management module, edit a user account.

2. On the User pop-up window, click View History.

   

Customers

1. In the Customers module, edit a customer.

2. On the Customer info window, click View History.

   

Primary Standard Management

1. In the Primary Standard Management grid, click on either the Add/Edit icon

2. On the Add/Edit pop-up window, click View History.

   

Calibrations

1. In the Calibrations Module, edit a Primary Standard

2. On the Edit form, click View History.

   

Event Configuration

1. The Event Configuration module can be accessed from the Administration drop-down menu

2. On the Event Configuration grid, right-click an Event type.

   

   

Chamber Configuration

1. On the Chamber Configuration module, click View History.

System Configuration

1. In the System Configuration module, click View History.

   

Equipment/Phase Configuration

1. On the Equipment/Phase Configuration form, click View History.

   

Group Management

1. On the group management grid, Edit a group.

2. Click View History.

   

Drum Management

1. On the drum management grid, edit a Drum.

2. On the Add/Edit pop-up window, click View History.